<?php

class JobeetCategoryTable extends Doctrine_Table
{
    public function getWithJobs()
    {
        $q = $this->createQuery('c')
                ->leftJoin('c.JobeetJobs j')
                ->where('j.expires_at > ?',date('Y-m-d H:i:s', time()));
        return $q->execute();
    }
}